https://store-images.s-microsoft.com/image/apps.2676.72807def-158f-4624-b081-77ea3119057a.5e976c2e-ca48-4cfa-acd7-2204de13b0c1.b44b489d-d149-4c08-b232-ac01ed5e19f5

Data Imports and Migration

by ERP Connect Consulting LLC

Free trial badge

Load and Migrate Data in 90% Less Time Than with Configuration Packages

Data Imports

  • Historical GL data loads during implementation cycles to avoid lengthy Config Pack Uploads
        • Typically takes 90% less time than a configuration package.
  • Loading large monthly journal entries.
  • Reduce loading and wait times on configuration packages and edit in Excel.
  • Ability to load Accounts Payable transactions into General Journals
  • Ability to load Accounts Receivable transactions into General Journals
  • Ability to use translation table in Business Central to avoid mapping in file
        • Map old Chart of Accounts to New Chart of Accounts + Dimensions in Business Central
        • Removes the complexities of having to Map this in the import file

Data Migrations
- When setting up new companies
- When pushing data between sandboxes and production (or vice versa)
- Allows you to do mass imports from company to company for dozens of standard tables in Business Central
Sales (Customer, Setups, Items, etc.)
Purchasing (Vendors, Setups, Items, etc.)
General Ledger (COA, Dimensions, Setups, etc.)
Fixed Assets (FA Card, Setups,)
Financial Reports
When creating new companies within the same organization
Bi-directionally pushing data between different business central companies like production vs test.
We are not exporting and importing like a configuration package which could take hours to move all of this data
We are doing a direct data transfer and only takes minutes instead of hours
Pre-filter the data
only move customers in canada
only move customers with posting group domestic
only move revenue chart of accounts
only move items that have been updated in the last 12 months
only move items with a certain posting group
etc.


At a glance

https://store-images.s-microsoft.com/image/apps.9414.72807def-158f-4624-b081-77ea3119057a.320b57ab-fd34-4148-80f4-878f4a12c3aa.e528beb4-43d0-4d6a-a639-3eb54af99879
/staticstorage/linux/20241105.1/assets/videoOverlay_7299e00c2e43a32cf9fa.png
https://store-images.s-microsoft.com/image/apps.45659.72807def-158f-4624-b081-77ea3119057a.320b57ab-fd34-4148-80f4-878f4a12c3aa.f6c08faf-cfe0-42ff-a8af-7961ddb359f5
/staticstorage/linux/20241105.1/assets/videoOverlay_7299e00c2e43a32cf9fa.png
https://store-images.s-microsoft.com/image/apps.34070.72807def-158f-4624-b081-77ea3119057a.5e976c2e-ca48-4cfa-acd7-2204de13b0c1.25d2b5c5-f939-4291-8c7d-d5d2c5b2f230
/staticstorage/linux/20241105.1/assets/videoOverlay_7299e00c2e43a32cf9fa.png
https://store-images.s-microsoft.com/image/apps.27363.72807def-158f-4624-b081-77ea3119057a.5e976c2e-ca48-4cfa-acd7-2204de13b0c1.7828ca79-78a0-4e97-8cfb-515559e0ada6
https://store-images.s-microsoft.com/image/apps.3028.72807def-158f-4624-b081-77ea3119057a.5e976c2e-ca48-4cfa-acd7-2204de13b0c1.3ef85db3-6de3-4f1e-8184-aae6dc9ccda8
https://store-images.s-microsoft.com/image/apps.62880.72807def-158f-4624-b081-77ea3119057a.5e976c2e-ca48-4cfa-acd7-2204de13b0c1.0b80b89d-e6ec-43e2-968c-e1a862ae88c7